SQL Server Integration Services
- SSIS Working and Control Flow Options
- SSIS Local and Global Variables - Usage
- Dynamic Precedence Constraints
- Dynamic Connection Managers in DFT
- Data Flow Transformations and Usage
- Handling ETL Enumerations in SSIS
- ETL with Loops & Indexed Connections
- Fast Load Options in OLE-DB Connections
- Combining and Splitting Data
- Performing SQL Database Operations
- MERGE Transformations
- UNION ALL Transformations
- Lookup Transformations
- ETL - Partial and Full Cache Options
- Fuzzy Lookup and
- Fuzzy Grouping
- SORT Transformations
- AGGREGATE Transformations
- Data Analytics and Column Profiling
- Data Sampling and Data Delta
- Type I and Type II SCD Examples
- Containers
- Execute SQL TASK
- Variables and Parameters
- Dimension Table Design
- SCD - Business Keys and Attributes
- SCD - Historical Attributes and Status
- Fact Table Loads and ETL Load IDs
- PIVOT Transformation
- UNPIVOT Transformation
- OLE-DB Command Usage & Parameters
- Derived Columns & Data Conversions
- SSIS Parameter Mappings & Options
- Configuring Child Packages, Parameters
- Parameter Bindings, Execute Process
- File System Task
- Need for Fact Tables and Techniques
- Dimensions to Fact Table Relations in DWH
- Fact Table Design and Data Load Techniques
- Dimension to Fact ETL Operations
- Generating Time Dimensions for DWH with ETL
- Master Child Packaging for Fact Loads
- Configuration